from common.sqlhandler import DBHandler
import yaml

from common.excelhandler import Excelhandler
from common.generate_phone import create_phone
from common.loger_handler2 import LoggerHandler
from common.requesthandler import HttpHandler
from common.sqlhandler import DBHandler
from config.setting import config

with open(config.yaml_path, ) as f:
    yamal_data = yaml.load(f.read(), Loader=yaml.FullLoader)

db = DBHandler(host=yamal_data['DBdatabase']['host'],
                            port=yamal_data['DBdatabase']['port'],
                            user=yamal_data['DBdatabase']['user'],
                            password=yamal_data['DBdatabase']['password'],
                            charset=yamal_data['DBdatabase']['charset'],
                            database=yamal_data['DBdatabase']['database']
                            )
db.dbclose()